/**
 * 
 */
package arisufascion.com.db;

/**
 * @author Kelvin
 *
 */
public class TblProfile {
	
	
	public static final String COLUMN_ID = "id";
	public static final String COLUMN_NAME = "name";
	public static final String COLUMN_COMPANY_NAME="company_name";
	public static final String COLUMN_EMAIL="email";
	public static final String COLUMN_TITLE="title";
	public static final String COLUMN_FIRST_NAME="first_name";
	public static final String COLUMN_LAST_NAME="last_name";
	public static final String COLUMN_MIDDLE_NAME="middle_name";
	public static final String COLUMN_PHONE_1="phone_1";
	public static final String COLUMN_PHONE_2="phone_2";
	public static final String COLUMN_FAX="fax";
	public static final String COLUMN_ADDRESS_1="address_1";
	public static final String COLUMN_ADDRESS_2="address_2";
	public static final String COLUMN_CITY="city";
	public static final String COLUMN_COUNTRY_NAME="country_name";
	public static final String COLUMN_COUNTRY_ID="country_id";
	public static final String COLUMN_STATE_NAME="state_name";
	public static final String COLUMN_STATE_ID="state_id";
	public static final String COLUMN_ZIP="zip";
	public static final String COLUMN_CREATED_ON="created_on";
	public static final String TABLE_NAME = "tblprofile";
	
	public static final String TABLE_CREATE = "create table if not exists " + TABLE_NAME + "(" 
			+ COLUMN_ID + " integer primary key, " 
			+ COLUMN_NAME + " text, "
			+ COLUMN_COMPANY_NAME + " text, " 
			+ COLUMN_EMAIL + " text, " 
			+ COLUMN_TITLE + " text, "
			+ COLUMN_FIRST_NAME + " text, " 
			+ COLUMN_MIDDLE_NAME + " text, "
			+ COLUMN_LAST_NAME + " text, "
			+ COLUMN_PHONE_1 + " integer, "
			+ COLUMN_PHONE_2 + " integer, "
			+ COLUMN_FAX+ " integer, "
			+ COLUMN_ADDRESS_1+ " text, "
			+ COLUMN_ADDRESS_2 + " text, "
			+ COLUMN_CITY + " text, "
			+ COLUMN_COUNTRY_NAME + " text, "
			+ COLUMN_COUNTRY_ID+ " integer, "
			+ COLUMN_STATE_NAME + " text, "
			+ COLUMN_STATE_ID + " integer, "
			+ COLUMN_ZIP + " text, "
			+ COLUMN_CREATED_ON+ " text "
			+ ")";
	
	public static final String TABLE_DROP = "Drop table if exists " + TABLE_NAME;
}
